SQL Azure does not support this tab.
Automatic
Auto Close
If this option is on, the database is shut down cleanly and its resources are freed after the last user exits.
Auto Create Statistics
If this option is on, the query optimizer creates statistics on single columns in query predicates, as necessary, to improve query plans and query performance.
Auto Shrink
If this option is on, the database files are candidates for periodic shrinking.
Auto Update Statistics
Specify that the query optimizer updates statistics when they are used by a query and when they might be out-of-date.
Auto Update Statistics Asynchronously
Specify that statistics updates for the AUTO_UPDATE_STATISTICS option are asynchronous. The query optimizer does not wait for statistics updates to complete before it compiles queries.Note: Support from SQL Server 2005 or later.
Change Tracking
Note: Support from SQL Server 2008 or later.
Change Tracking
Enable change tracking for the database. When you enable change tracking, you can also set the AUTO CLEANUP and CHANGE RETENTION options.Retention Period
Specifies the minimum period for keeping change tracking information in the database. Data is removed only when the AUTO_CLEANUP value is ON.
Auto Cleanup
Change tracking information is automatically removed after the specified retention period.
Cursor
Close Cursor On Commit Enabled
If this option is on, any cursors open when a transaction is committed or rolled back are closed.Default Cursor
LOCAL
When LOCAL is specified and a cursor is not defined as GLOBAL when created, the scope of the cursor is local to the batch, stored procedure, or trigger in which the cursor was created. The cursor name is valid only within this scope. The cursor can be referenced by local cursor variables in the batch, stored procedure, or trigger, or a stored procedure OUTPUT parameter. The cursor is implicitly deallocated when the batch, stored procedure, or trigger ends, unless it was passed back in an OUTPUT parameter. If the cursor is passed back in an OUTPUT parameter, the cursor is deallocated when the last variable that references it is deallocated or goes out of scope.GLOBAL
When GLOBAL is specified, and a cursor is not defined as LOCAL when created, the scope of the cursor is global to the connection. The cursor name can be referenced in any stored procedure or batch executed by the connection.
Recovery
Page Verify
Discovers damaged database pages caused by disk I/O path errors. Disk I/O path errors can be the cause of database corruption problems and are generally caused by power failures or disk hardware failures that occur at the time the page is being written to disk.NONE
Database page writes will not generate a CHECKSUM or TORN_PAGE_DETECTION value. SQL Server will not verify a checksum or torn page during a read even if a CHECKSUM or TORN_PAGE_DETECTION value is present in the page header.TORN_PAGE_DETECTION
Save a specific 2-bit pattern for each 512-byte sector in the 8-kilobyte (KB) database page and stored in the database page header when the page is written to disk.CHECKSUM
Calculate a checksum over the contents of the whole page and stores the value in the page header when a page is written to disk.
Service Broker
Note: Support from SQL Server 2005 or later.
Broker Enabled
Specify that Service Broker is enabled for the specified database. Message delivery is started, and the is_broker_enabled flag is set to true in the sys.databases catalog view. The database retains the existing Service Broker identifier.
Honor Broker Priority
Send operations take into consideration the priority levels that are assigned to conversations. Messages from conversations that have high priority levels are sent before messages from conversations that are assigned low priority levels.Note: Support from SQL Server 2008 or later.
SQL
ANSI Null Default
Checks this option if you want to determines the default value as NULL.
ANSI NULLS Enabled
If this option is on, all comparisons to a null value evaluate to UNKNOWN.
ANSI Padding Enabled
If this option is on, strings are padded to the same length before conversion or inserting to a varchar or nvarchar data type.
ANSI Warnings Enabled
If this option is on, errors or warnings are issued when conditions such as divide-by-zero occur or null values appear in aggregate functions.
Arithmetic Abort Enabled
If this option is on, a query is ended when an overflow or divide-by-zero error occurs during query execution.
Concatenate Null Yields Null
If this option is on, the result of a concatenation operation is NULL when either operand is NULL.
Numeric Round-Abort
If this option is on, an error is generated when loss of precision occurs in an expression.
Quoted Identifiers Enabled
If this option is on, double quotation marks can be used to enclose delimited identifiers.
Recursive Triggers Enabled
If this option is on, Recursive firing of AFTER triggers is allowed.
State
Database Read-Only
If this option is on, users can read data from the database but not modify it.Database State
Choose the state of the database.OFFLINE
The database is closed, shut down cleanly, and marked offline. The database cannot be modified while it is offline.ONLINE
The database is open and available for use.EMERGENCY
The database is marked READ_ONLY, logging is disabled, and access is limited to members of the sysadmin fixed server role. EMERGENCY is primarily used for troubleshooting purposes.Restrict Access
Control user access to the database.SINGLE_USER
Specifies that only one user at a time can access the database.RESTRICTED_USER
RESTRICTED_USER allows for only members of the db_owner fixed database role and dbcreator and sysadmin fixed server roles to connect to the database, but does not limit their number.MULTI_USER
All users that have the appropriate permissions to connect to the database are allowed.
Encryption Enabled
Checks this option if you want to encrypt the database.Note: Support from SQL Server 2008 or later.
Miscellaneous
Note: Support from SQL Server 2005 or later.
Cross-database Ownership Chaining Enabled
If this option is on, database can be the source or target of a cross-database ownership chain.
Trustworthy
If this option is on, database modules (for example, user-defined functions or stored procedures) that use an impersonation context can access resources outside the database.
Date Correlation Optimization Enabled
SQL Server maintains correlation statistics between any two tables in the database that are linked by a FOREIGN KEY constraint and have datetime columns.Parameterization
SIMPLE
Queries are parameterized based on the default behavior of the database.FORCED
SQL Server parameterizes all queries in the database.
VarDecimal Storage Format Enabled
Indicate that decimal and numeric data types are stored by using the vardecimal storage format.